import pandas

def readExcel():
    pf = pandas.read_excel('test.xlsx')
#     计算平均年龄
    s = pf[["age"]].sum()
    s.to_excel("a.xlsx")

if __name__ == '__main__':
    readExcel()